{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Assumptions","Student Costs","Institutional Costs","Summer and Intersession Costs","Cost Summary Sheet","RefHidden"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Assumptions","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,2,1],[18,1,18,2],[10,1,10,2],[1,2,2,2]]}
[null,"California College Promise Project (CCPP) Cost Estimator Tool\nProgram Assumptions"]
[null,"Instructions: Please include information for one cohort of College Promise program participants. This data on the scope and length of your program will allow the tool to compute your program cost."]
[]
[]
[null,"How many terms are covered by your College Promise program? (Do not include coverage for summer or intersession terms -- this will be covered in the \"Summer & Intersession Costs\" tab.)",4]
[null,"Does your college use the semester or quarter  system?","semester"]
[null,"Terms to be included per year",{"$f":"IF(C6=\"quarter\",3,2)","v":2}]
[]
[null,"What is the average number of units per term that will be covered for your College Promise participants? (Consider your program's minimum enrollment requirement, if relevant, and previous trend data.)",14]
[]
[null,"What are the estimated retention rates for your College Promise participants? "]
[null,{"$f":"\"Average retention rate from the first to second \" & C6","v":"Average retention rate from the first to second semester"},0.71]
[null,"Average retention from first to third quarter",1]
[null," Average retention rate from first to second year",0.47]
[null,"How many students do you anticipate will be participating in the program? (Consider previous enrollment data and the program's eligibility requirements) ",2704]
[]
[null,"What percent of the College Promise program participants do you estimate will be eligible for the California College Promise Grant (CCPG)?",0.74]
[]
[null,{"$f":"\"Status: \" & IF(AND(C5<>0,C9<>0,C15<>0,C17<>0),\"Complete. Proceed to the Student Costs tab\",\"Possibly Incomplete Information. Please check before proceeding.\")","v":"Status: Complete. Proceed to the Student Costs tab"}]

{"sheet":"Student Costs","index":1,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,25,3],[0,1,0,3],[20,1,20,2],[1,1,2,2],[3,1,3,3]]}
[null,"California College Promise Project (CCPP) Cost Estimator Tool\nPart I: Calculate Student Support Costs "]
[]
[]
[]
[null,"Other Student Financial Support","Cost per Student / Term","Percent of College Promise Students Receiving Support"]
[]
[null,"Student Activities",1,1]
[null,"Health Fees ",20,1]
[null,"Transportation",0,0]
[null,"Book / Course Materials",0,0]
[null,"Other",5,0.3]
[]
[null,"Estimates","Number of Students","Cost"]
[null,"First term",{"$f":"ROUND(((1-Assumptions!C17)*Assumptions!C15),0)","v":703},{"$f":"IF(Assumptions!$C$9<>0,(46*C14*Assumptions!$C$9)+(C14*C7*D7)+(C14*C8*D8)+(C14*C9*D9)+(C14*C10*D10)+(C14*C11*D11),0)","v":468549.5}]
[null,{"$f":"\"2nd Term (\"& (Assumptions!C12)*100 &\"% Retention Rate)\"","v":"2nd Term (71% Retention Rate)"},{"$f":"IF(Assumptions!C5>1,ROUND(Assumptions!C12*'Student Costs'!C14,0),\"NA\")","v":499},{"$f":"IF(C15=\"NA\",0,IF(Assumptions!$C$9<>0,(46*C15*Assumptions!$C$9+(C15*C7*D7)+(C15*C8*D8)+(C15*C9*D9)+(C15*C10*D10)+(C15*C11*D11)),0))","v":332583.5}]
[null,{"$f":"\"3rd Term \"&\"(\"&(Assumptions!C13)*100&\"% Retention Rate)\"","v":"3rd Term (100% Retention Rate)"},{"$f":"IF(AND(Assumptions!C6=\"quarter\",Assumptions!C5>2),ROUND('Student Costs'!C15*Assumptions!C13,0),0)","v":0},{"$f":"IF(Assumptions!$C$9<>0,(46*C16*Assumptions!$C$9+(C16*C7*D7)+(C16*C8*D8)+(C16*C9*D9)+(C16*C10*D10)+(C16*C11*D11)),\"NA\")","v":0}]
[null,{"$f":"\"2nd Year, First Term (\" & Assumptions!C14*100 & \"% Retention Rate)\"","v":"2nd Year, First Term (47% Retention Rate)"},{"$f":"IF(AND(Assumptions!C6=\"semester\",Assumptions!C5>2),ROUND(C15*Assumptions!C14,0),IF(AND(Assumptions!C6=\"quarter\",Assumptions!C5>3),ROUND(C16*Assumptions!C14,0)))","v":235},{"$f":"IF(C17=0,0,(46*C17*Assumptions!$C$9+(C17*C7*D7)+(C17*C8*D8)+(C17*C9*D9)+(C17*C10*D10)+(C17*C11*D11)))","v":156627.5}]
[null,"2nd Year, 2nd Term (Assuming 0% attrition)",{"$f":"IF(AND(Assumptions!C6=\"semester\",Assumptions!C5>3),C17,IF(AND(Assumptions!C6=\"quarter\",Assumptions!C5>4),C17,0))","v":235},{"$f":"IF(C18=0,0,(46*C17*Assumptions!$C$9+(C17*C7*D7)+(C17*C8*D8)+(C17*C9*D9)+(C17*C10*D10)+(C17*C11*D11)))","v":156627.5}]
[null,"2nd Year, 3rd Term (Assuming 0% attrition)",{"$f":"IF(Assumptions!C6=\"semester\",0,IF(Assumptions!C5=6,C18,0))","v":0},{"$f":"IF(C19=0,0,(46*C17*Assumptions!$C$9+(C17*C7*D7)+(C17*C8*D8)+(C17*C9*D9)+(C17*C10*D10)+(C17*C11*D11)))","v":0}]
[]
[null,"Part I, Running Yearly Totals"]
[null,"Year 1",{"$f":"IF(Assumptions!C7=3,SUM(D14:D16),IF(Assumptions!C7=2,SUM('Student Costs'!D14:D15),\"NA\"))","v":801133}]
[null,"Year 2",{"$f":"SUM(D17:D19)","v":313255}]
[null,"Total",{"$f":"IF(AND(C23=\"NA\",C22=\"NA\"),\"NA\",SUM(C22:C23))","v":1114388}]
[null,{"$f":"IF(SUM(C7:C11)>0,\"\",\"Please verify that all student financial support information is correct before proceeding to the Institutional Costs tab.\")","v":""}]

{"sheet":"Institutional Costs","index":2,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[23,1,23,2],[1,1,2,2],[0,1,0,2]]}
[null,"California College Promise Project (CCPP) Cost Estimator Tool\nPart II: Calculate Institutional-Level Program Costs "]
[]
[]
[]
[]
[null,"Staffing","Cost Per Year"]
[null,"Position 1",72000]
[null,"Position 2",0]
[null,"Position 3",0]
[null,"Position 4",0]
[null,"Position 5",0]
[]
[]
[null,"Events, Professional Development, and other Costs","Cost Per Year"]
[null,"Events and meetings",5000]
[null,"Professional development (conferences, workshops, trainings)",5000]
[null,"Materials and publications",20000]
[null,"Subcontracts",56000]
[null,"Other",0]
[null,"Other",0]
[null,"Other",0]
[]
[]
[null,"Part II, Running Yearly Totals"]
[null,"Year 1",{"$f":"IF('Student Costs'!C22=\"NA\",\"NA\",SUM(C7:C11,C15:C21)+'Student Costs'!C22)","v":959133}]
[null,"Year 2",{"$f":"IF('Student Costs'!C23=0,0,SUM(C7:C11,C15:C21)+'Student Costs'!C23)","v":471255}]
[null,"Total",{"$f":"IF(C25=\"NA\",\"NA\",C25+C26)","v":1430388}]

{"sheet":"Summer and Intersession Costs","index":3,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,2,3],[20,1,20,2],[4,1,4,2],[7,1,7,2],[9,1,9,2],[11,1,11,2]]}
[null,"California College Promise Project (CCPP) Cost Estimator Tool\nPart III: Summer and Intersession Costs"]
[null,"Instructions: Include information about summer sessions \nand/or intersessions that are covered in your College Promise program."]
[]
[]
[null,"How many summer sessions and/or intersessions will be covered in your College Promise program?",null,0]
[]
[]
[null,"What is the average number of units per summer or intersession term that will be covered for your College Promise participants?",null,0]
[]
[null,"How many College Promise students do you anticipate participating in each summer or intersession?",null,0]
[]
[null,"What percent of these students are eligible for CCPG?",null,0]
[]
[null,"Other Student Financial Support","Cost per Student / Term","Percent of College Promise Students Who Will Receive Support"]
[null,"Student Activities",0,0]
[null,"Health",0,0]
[null,"Transportation",0,0]
[null,"Book/course materials",0,0]
[null,"Other",0,0]
[]
[null,"Part III, Running Yearly Totals"]
[null,"Year 1",{"$f":"'Institutional Costs'!C25","v":959133}]
[null,"Year 2",{"$f":"'Institutional Costs'!C26","v":471255}]
[null,"Summer and Intersession",{"$f":"D5*(('Summer and Intersession Costs'!D8*46*('Summer and Intersession Costs'!D10*D12))+((D12*D10*C16*D16)+(D12*D10*C15*D15)+(D12*D10*C17*D17)+(D12*D10*C18*D18)+(D12*D10*C19*D19)))","v":0}]
[null,"Total",{"$f":"IF(C22=\"NA\",\"NA\",C22+C23+C24)","v":1430388}]

{"sheet":"Cost Summary Sheet","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"California College Promise Project (CCPP) Cost Estimator Tool\nTotal Cost Summary Sheet"]
[]
[null,null,"Year 1","Year 2","Summer/\nIntersession","Totals"]
[null,"Tuition Fees",{"$f":"46*Assumptions!C9*(SUM('Student Costs'!C14:C16))","v":774088},{"$f":"46*Assumptions!C9*(SUM('Student Costs'!C17:C19))","v":302680},{"$f":"46*'Summer and Intersession Costs'!D8*'Summer and Intersession Costs'!D10*'Summer and Intersession Costs'!D5*'Summer and Intersession Costs'!D12","v":0},{"$f":"SUM(C4:E4)","v":1076768}]
[null,"Health Fees",{"$f":"'Student Costs'!C8*('Student Costs'!D8*(SUM('Student Costs'!C14:C16)))","v":24040},{"$f":"'Student Costs'!C8*('Student Costs'!D8*(SUM('Student Costs'!C17:C19)))","v":9400},{"$f":"'Summer and Intersession Costs'!C15*'Summer and Intersession Costs'!D15*'Summer and Intersession Costs'!D10*'Summer and Intersession Costs'!D5*'Summer and Intersession Costs'!D12","v":0},33440]
[null,"Student Activities",{"$f":"'Student Costs'!C7*('Student Costs'!D7*(SUM('Student Costs'!C14:C16)))","v":1202},{"$f":"'Student Costs'!C7*('Student Costs'!D7*(SUM('Student Costs'!C17:C19)))","v":470},{"$f":"'Summer and Intersession Costs'!D10*'Summer and Intersession Costs'!C16*'Summer and Intersession Costs'!D16*'Summer and Intersession Costs'!D5*'Summer and Intersession Costs'!D12","v":0},1672]
[null,"Transportation",{"$f":"'Student Costs'!C9*('Student Costs'!D9*(SUM('Student Costs'!C14:C16)))","v":0},{"$f":"'Student Costs'!C9*('Student Costs'!D9*(SUM('Student Costs'!C17:C19)))","v":0},{"$f":"'Summer and Intersession Costs'!C17*'Summer and Intersession Costs'!D17*'Summer and Intersession Costs'!D10*'Summer and Intersession Costs'!D5*'Summer and Intersession Costs'!D12","v":0},0]
[null,"Book/course Materials",{"$f":"'Student Costs'!C10*('Student Costs'!D10*(SUM('Student Costs'!C14:C16)))","v":0},{"$f":"'Student Costs'!C10*('Student Costs'!D10*(SUM('Student Costs'!C17:C19)))","v":0},{"$f":"'Summer and Intersession Costs'!C18*'Summer and Intersession Costs'!D18*'Summer and Intersession Costs'!D10*'Summer and Intersession Costs'!D5*'Summer and Intersession Costs'!D12","v":0},0]
[null,"Other",{"$f":"'Student Costs'!C11*('Student Costs'!D11*(SUM('Student Costs'!C14:C16)))","v":1802.9999999999998},{"$f":"'Student Costs'!C11*('Student Costs'!D11*(SUM('Student Costs'!C17:C19)))","v":705},{"$f":"'Summer and Intersession Costs'!C19*'Summer and Intersession Costs'!D19*'Summer and Intersession Costs'!D10*'Summer and Intersession Costs'!D5*'Summer and Intersession Costs'!D12","v":0},2508]
[null,"Staffing",{"$f":"SUM('Institutional Costs'!C7:C11)","v":72000},{"$f":"IF(OR(AND(Assumptions!C6=\"quarter\",Assumptions!C5>3),AND(Assumptions!C6=\"semester\",Assumptions!C5>2)),SUM('Institutional Costs'!C7:C11),0)","v":72000},"NA",144000]
[null,"Events/Professional Development",{"$f":"SUM('Institutional Costs'!C15:C21)","v":86000},{"$f":"IF(OR(AND(Assumptions!C6=\"semester\",Assumptions!C5>2),AND(Assumptions!C6=\"quarter\",Assumptions!C5>3)),SUM('Institutional Costs'!C15:C21),0)","v":86000},"NA",172000]
[null,"Totals",{"$f":"SUM(C4:C11)","v":959133},{"$f":"SUM(D4:D11)","v":471255},{"$f":"SUM(E4:E9)","v":0},{"$f":"SUM(F4:F11)","v":1430388}]

{"sheet":"RefHidden","index":5,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["semester"]
["quarter"]